home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
faredescriptions.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
984b
|
23 lines
/* RCSVER $Id: faredescriptions.sql,v 1.8 1999-12-02 16:55:37-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: faredescriptions.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the faredescriptions table. This table contains
* definitions of all fare descriptions (fare types) defined
* to the system.
* Changes: 05-24-99 RNW: Removed description to the faretable table.
************************************************************************* */
CREATE TABLE faredescriptions
(
id NUMBER(38), /* ID of this fare type */
class_num NUMBER(38), /* Default fare class of this type */
config_num NUMBER(38)
CONSTRAINT ref_faredescriptions1 REFERENCES configset(num)
ON DELETE CASCADE,
default_descr VARCHAR2(20), /* Default description */
CONSTRAINT pk_faredescriptions PRIMARY KEY (id, config_num)
);